number of errors=27
number of warnings=0
country=CN
select geonameid,name,ansiname,featurecode,countrycode,admincode1,admincode2,admincode3,admincode4,admincode5 from geoname where countrycode='CN' and featurecode='ADM2' and not exists (select 1 from countrysubdiv_code where validtill is null and countrysubdiv_code.countrycode='CN' and countrysubdiv_code.featurecode='ADM2' and geoname.admincode1=countrysubdiv_code.admincode1 and geoname.admincode2=countrysubdiv_code.admincode2) order by admincode1,admincode2,admincode3,admincode4,admincode5
333 from China NBS
geonameid name ansiname featurecode countrycode admincode1 admincode2 admincode3 admincode4 admincode5 12324210 Jiyuan Jiyuan ADM2 CN 09 12324210 null null null 12324193 Tianmen Tianmen ADM2 CN 12 12324193 null null null 12324199 Qianjiang Qianjiang ADM2 CN 12 12324199 null null null 12324200 Xiantao Xiantao ADM2 CN 12 12324200 null null null 1795614 Shennongjia Shennongjia ADM2 CN 12 1795614 null null null 12324192 Shihezi Shihezi ADM2 CN 13 12324192 null null null 8079473 Wujiaqu Shi Wujiaqu Shi ADM2 CN 13 8079473 null null null 8080762 Tumxuk Tumxuk ADM2 CN 13 8080762 null null null 11876380 Beijing Beijing ADM2 CN 22 11876380 null null null 12324204 Shanghai Municipality Shanghai Municipality ADM2 CN 23 12324204 null null null 12324202 Tianjin Municipality Tianjin Municipality ADM2 CN 28 12324202 null null null 12324194 Wuzhishan City Wuzhishan City ADM2 CN 31 12324194 null null null 12324195 Ledong Li Autonomous County Ledong Li Autonomous County ADM2 CN 31 12324195 null null null 12324196 Dongfang City Dongfang City ADM2 CN 31 12324196 null null null 12324197 Changjiang Li Autonomous County Changjiang Li Autonomous County ADM2 CN 31 12324197 null null null 12324198 Lingao County Lingao County ADM2 CN 31 12324198 null null null 12324201 Lingshui Li Autonomous County Lingshui Li Autonomous County ADM2 CN 31 12324201 null null null 12324203 Baoting Li and Miao Autonomous County Baoting Li and Miao Autonomous County ADM2 CN 31 12324203 null null null 12324205 Tunchang County Tunchang County ADM2 CN 31 12324205 null null null 12324206 Ding'an County Ding'an County ADM2 CN 31 12324206 null null null 12324207 Baisha Li Autonomous County Baisha Li Autonomous County ADM2 CN 31 12324207 null null null 12324208 Qiongzhong Li and Miao Autonomous County Qiongzhong Li and Miao Autonomous County ADM2 CN 31 12324208 null null null 12324209 Chengmai County Chengmai County ADM2 CN 31 12324209 null null null 1791540 Wenchang Shi Wenchang Shi ADM2 CN 31 1791540 null null null 1791778 Wanning Shi Wanning Shi ADM2 CN 31 1791778 null null null 1797544 Qionghai County Qionghai County ADM2 CN 31 1797544 null null null 8739734 Chongqing Chongqing ADM2 CN 33 8739734 null null null